In article <foo.bar%gl.umbc.edu960115>, you wrote:
>*----- Do Not Erase Anything After This Line -----*
>
>1995 RAC* COMIC AWARDS BALLOT <RCAB95>
>
>#A1 Example Category : write your vote after each colon, like this
>
>#C1 Writer : Neil Gaiman
>#C2 Penciller : Edward Gorey
>#C3 Inker :
>#C4 Painter :Herman Head (or maybe I mean that guy on TV)
>#C5 Letterer : Comicraft
>#C6 Colorist :Marie Javins
>#C7 Creative Team :Dave Sim & Gerhard
>#C8 Cover Artist : I dunno
>#C9 Editor : Diana Schutz, or is it Diana Shultz?
>
>#B1 Complete Story : Bone: "The Great Cow Race": (issues 7-12)
>#B2 Ongoing Series : THB
>#B3 New Series : Kurt Busiek's Astro City
>#B4 Limited Series : Kurt Busiek's Astro City (is this allowed?)
>#B5 Most Improved : Cerebus -- boy did I hate Melmoth
>#B6 Single Issue : Watchmen #11
>#B7 Graphic Novel : The Tragical Comedy or Comical Tragedy of Mister Punch
>#B8 Collection/TPB : Starchild
>
>#S1 Daily Strip : Calvinball
>#S2 Weekly Strip : Refrigerator Johnny
>#S3 Single Panel : Dysfunctional Family Circus, or maybe Life in Hall
>#S4 Pol. Cartoonist : Tom Tomorrow
>#S5 Collection : Doonesbury 25th Anniversary
>
>#M1 Company/Imprint : Paradox
>#M2 Character : Paragon
>#M3 Character Team : Dirty Pair
>#M4 Character Cast : Thorn/Granma/the Bones/Ted/the cows
>#M5 Adaptation : Maus CD-ROM
>#M6 Letter Column : Dread Letter Office
>
>#W1 Publication : TCJ
>#W2 Journalist : E.G.O.
>#W3 Online Forum : rec.arts.comics.info
>#W4 Web Site : http://www.redweb.com/wraithspace
>#W5 RAC'er (1) : mac7@po.cwru.edu
>#W6 RAC'er (2) :
>#W7 RAC'er (3) : RobRaza McClean
>
>#Z1 <FAUY95>
>
>-F
>.
--
I want to convert these ballots into a single long line of
tab-delimited text, starting with the From: and Date: headers,
then the votes, including blanks. My plan is to take these
text lines and paste them into an Excel spreadsheet, with
a column for each vote category. Example conversion:
Aldous Huxley <h1984@paranoia.io.com> Wed Jan 17 15:03:25 EST 1996 Neil Gaiman Edward Gorey Herman Head (or maybe I mean that guy on TV) Comicraft (etc)
Note the double tab after Edward Gorey for the skipped category.
And if possible, elminating tabs that are typed into votes would
be a plus, but not mandatory. Thanks for any help.